Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
public usersnotified (table)
Print
RSS
Modified on 2011/08/27 11:44
by
wikibot
Categorized as
Uncategorized
public notifications (table)
dbo Name (type)
HumanResources vEmployee (view)
Person (schema)
Person StateProvince (table)
Person vStateProvinceCountryRegion (view)
Purchasing vVendor (view)
Sales CountryRegionCurrency (table)
Sales vIndividualCustomer (view)
Sales vSalesPerson (view)
Sales vStoreWithDemographics (view)
SH COSTS (table)
SH SALES (table)
public events (table)
public ifservices (table)
public node (table)
public service (table)
public location_monitors (table)
HumanResources Employee (table)
HumanResources EmployeeAddress (table)
Person Address (table)
Person Contact (table)
Person CountryRegion (table)
Person StateProvince (table)
Sales (schema)
Sales SalesPerson (table)
Sales SalesTerritory (table)
public ifservices (table)
public outages (table)
public notifications (table)
dbo Name (type)
HumanResources vEmployee (view)
Person (schema)
Person StateProvince (table)
Person vStateProvinceCountryRegion (view)
Purchasing vVendor (view)
Sales CountryRegionCurrency (table)
Sales vIndividualCustomer (view)
Sales vSalesPerson (view)
Sales vStoreWithDemographics (view)
SH COSTS (table)
SH SALES (table)
(7)
»
SH PRODUCTS (table)
»
Person CountryRegion (table)
»
public usersnotified (table)
[X]
»
public service (table)
»
Sales vSalesPerson (view)
»
public location_monitor_details (table)
»
public outages (table)
»
SH PRODUCTS (table)
»
Person CountryRegion (table)
»
public usersnotified (table)
wikibot
¶
Table
public.usersnotified
Columns
¶
Column
Data Type
Nullable
Default
Description
id
integer
not null
userid
varchar(256)
not null
notifyid
integer
null
notifytime
timestamp with time zone
null
media
varchar(32)
null
contactinfo
varchar(64)
null
autonotify
char(1)
null
Primary Key
¶
Primary Key
Columns
pk_usernotificationid
id
Indexes
¶
Index
Type
Columns
userid_notifyid_idx
userid, notifyid
Foreign Keys
¶
Relation
Column
Referenced Column
public.notifications
notifyid
notifyid
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.